How to: Create a new table from scratch using Design view (without Wizards).
Solution:
Click the 'Tables' tab in the Database window, click 'New', and select 'Design View'.
NOTE: Never include a calculated field in the table.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Click 'New'. (The New Table dialog box appears.)
4) Select 'Design View' from the list box.
5) Click 'OK'. (The table design window appears.)
6) Define the table's fields:
a) In the first blank line of the 'Field Name' column, type a field name.
NOTE: A field name can contain up to 64 characters, including blanks; it should start with a letter or number, and punctuation marks should be avoided. Do NOT start the name with a space.
b) Click in the corresponding cell in the 'Data Type' column next to the field name. (A down arrow appears in the right of the cell.)
c) Click on the arrow. (A drop-down list appears.)
d) Select the desired data type from the drop-down list.
Data type
e) (Optional) Type a description of the field in the corresponding field in the 'Description' column.
f) (Optional) Set properties for the field:
1] Move to the 'Field Properties' section.
Field Properties section
2] Click the 'General' tab.
3] Make the desired entries and selections.
4] Click the 'Lookup' tab.
5] Make the desired entries and selections.
g) Repeat steps 6)a) through 6)f) for each field to be added.
7) Save the table structure:
a) Select the 'File' menu and select 'Save'. (The Save As dialog box appears.)
b) Type a name for the table in the 'Table Name' box.
c) Click 'OK'.
